package com.wz.wzbubbleai.database;

/**
 * Created by wangbin on 18-1-16.
 */

public class NewChatTable {
    public static final String TBL_NAME = "CHAT";
    public static final String CHAT_ID = "ID";
    public static final String CHAT_TYPE = "TYPE";
    public static final String CHAT_TEXT = "TEXT";
    public static final String CHAT_PLUG_NAME = "PLUGNAME";
    public static final String CHAT_PLUG_VERSION = "PLUGVERSION";
    public static final String CHAT_DESCRIPTION = "DESCRIPTION";

    public static String getCreatNetNewsSQL() {
        String sql = "CREATE TABLE IF NOT EXISTS "
                + TBL_NAME + "(" + CHAT_ID + " INTEGER PRIMARY KEY AUTOINCREMENT,"
                + CHAT_TYPE + " INTEGER,"
                + CHAT_TEXT + " TEXT,"
                + CHAT_PLUG_NAME + " VARCHAR(200),"
                + CHAT_PLUG_VERSION + " INTEGER,"
                + CHAT_DESCRIPTION + " TEXT"
                + ")";
        return sql;
    }
}
